========= EXEMPLES DU COURS =============

SELECT prenom FROM Eleves2018;
SELECT DISTINCT prenom FROM Eleves2018;

SELECT * FROM Eleves2018 WHERE prenom=='Elodie' OR lycee_origine=="Négal";

SELECT nom, prenom  FROM Eleves2018 WHERE filiere=='BCPST' AND lycee_origine=="Négal";

SELECT filiere AS section FROM Eleves2018 ;
SELECT prenom, nom, filiere AS section, numero FROM Eleves2018 ;

SELECT note_bac/2 AS note_sur_10 FROM Eleves2018 ;
SELECT prenom || ' ' || nom AS Eleve FROM Eleves2018 where lycee_origine=='Négal' ;

SELECT *  FROM Eleves2018 ORDER BY note_bac DESC ;
SELECT *  FROM Eleves2018 WHERE prenom LIKE 'P%' ;
SELECT prenom, E.nom, L.nom FROM Eleves E, Lycees L ;

SELECT * FROM Eleves E JOIN Lycees L ON E.id_L==L.id_L ;

SELECT AVG(note_bac)  FROM Eleves ;
SELECT lycee_origine, AVG(note_bac)  FROM Eleves2018 GROUP BY lycee_origine ;

SELECT lycee_origine, AVG(note_bac)  FROM Eleves2018 GROUP BY lycee_origine HAVING AVG(note_bac)>=13 ;

SELECT lycee_origine, AVG(note_bac)  FROM Eleves2018 WHERE numero==1 GROUP BY lycee_origine ;